RQ1: Student population
Column
First Iteration
Second Iteration
Final Iteration 1
Final Iteration 2
RQ1: Student and teacher
Column
Teacher population by race and ethnicity
Student and Teacher of Color
Student and Teacher of Color
RQ1: Student with year
Column
Change from 2018-2020 - Iteration 1
Change from 2018-2020 - Iteration 2
Change during Covid - Iteration 1
Change during Covid - Iteration 2
RQ2 RLA
Column 1
Research Question
How does the the proficiency level in Reading and Language skill vary across state for High School Students? How does it differ by students characteristics such as English Learner status, Student with Disability, Low Income students?
Data Source: State Assessments in Reading/Language Arts and Mathematics- School Year 2018-19 EDFacts Data Documentation, U.S. Department of Education, Washington, DC: EDFacts. Retrieved February 2, 2022 from http://www.ed.gov/edfacts
Column
Percent of students at and above Reading and Languange Proficiency Level based on characteristics across the States
Column
A. Children with disability
B. English language learner
C. Economically disadvantaged students
D. All Students
RQ2 Math
Column 1
Research Question
How does the the proficiency level in math vary across state for High School Students? Also, how does it vary across the US regions (i.e Midwest, Northeast, South, and West)?
Data Source: State Assessments in Reading/Language Arts and Mathematics- School Year 2018-19 EDFacts Data Documentation, U.S. Department of Education, Washington, DC: EDFacts. Retrieved February 2, 2022 from http://www.ed.gov/edfacts
Column
Math Proficiency by Regions
The south region has relatively high percentage of students at and above Math proficiency, in contrast, the West region has relatively low percentage of students at and above Math proficiency. There is no clear pattern for Midwest and Northeast regions as there is large variation of Math profiency within these regions.
Column
Diverging Bars for Math Scores
Diverging Lollipop Chart - Math
RQ2 Textbook Spending
Column 1
Research Question
How does the the proficiency level in Reading and Language skill vary across state for High School Students? How does it differ by students characteristics such as English Learner status, Student with Disability, Low Income students?
Data Source: Distric Fiscal documentation 2018 School year 2019 Retrieved February 2, 2022.
On Average, Indiana spent the most on textbook per student at $107, while Hawaii spent the least on textbook per student at $14.
Column
Textbook spending across the US
Column
Indiana
Virginia
West Virginia
Oregon
Oregon Colorblind Friendly Version
Color-blind OR Plot
RQ2 Achievement vs Spending
Column 1
Research Question
What is the relationship between District Textbook Funding per Student and Students’ Math and RLA achievements?
Data Source: State Assessments in Reading/Language Arts and Mathematics- School Year 2018-19 EDFacts Data Documentation, U.S. Department of Education, Washington, DC: EDFacts. Retrieved February 2, 2022 from http://www.ed.gov/edfacts
Column
Math & Textbook Spending
States with relatively low spending on textbook has lower students at and above Math proficiency level.
RLA & Textbook Spending
Math & Textbook Spending (Raw LM)
Column
Option 1
Math & Achievement gghighlight
Research Question 3
Column 1
Variables:
LEAID - ID number for each school district
total - Total number of students in a school district
textbk_exp_per_student - Textbook Expenditure per Student
percentM - Percent of student population in a school district identifying as minorities
percentW - Percent of student population in a school district identifying as white
Data Source: https://usafacts.org/
Column 2
Correlation Coefficients Table
| Total Number of Students per District | Textbook Expenditure per Student | Percent of Student Population Identifying as Minority | Percent of Student Population Identifying as White | |
|---|---|---|---|---|
| total | ||||
| textbk_exp_per_student | 0.00 | |||
| percentM | 0.21*** | 0.05*** | ||
| percentW | -0.21*** | -0.05*** | -1.00*** |
Initial Scatterplot
Scatterplot for Minority Students
Scatterplot for White Students
Column 3
Lowerbound Correlation Matrix
The ovals display the type of correlation direction, but there are no significance asterisks included for the correlations.
Initial Full Correlation Matrix
This initial version seems to busy with the large vs. small font sizes and red lines.
Second Full Correlation Matrix
This correlation matrix is missing the lines from the scatterplots, but it is cleaner visually with some overlap in x-axis labels.
Final Full Correlation Matrix
The color is more easily changed via the pairs.panels function.